/*
 Navicat MySQL Data Transfer

 Source Server         : java
 Source Server Type    : MySQL
 Source Server Version : 50717
 Source Host           : localhost
 Source Database       : kitadmin

 Target Server Type    : MySQL
 Target Server Version : 50717
 File Encoding         : utf-8

 Date: 03/12/2018 18:40:26 PM
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
--  Table structure for `kit_admin`
-- ----------------------------
DROP TABLE IF EXISTS `kit_admin`;
CREATE TABLE `kit_admin` (
  `kit_admin_id` varchar(111) NOT NULL COMMENT '用户id',
  `kit_admin_username` varchar(30) NOT NULL COMMENT '用户名',
  `kit_admin_password` varchar(32) NOT NULL COMMENT '密码',
  `kit_admin_name` varchar(20) NOT NULL COMMENT '名字',
  `kit_admin_img_url` varchar(100) NOT NULL COMMENT '头像地址',
  `group_id` int(2) NOT NULL COMMENT '用户所属分组',
  PRIMARY KEY (`kit_admin_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
--  Records of `kit_admin`
-- ----------------------------
BEGIN;
INSERT INTO `kit_admin` VALUES ('1', 'admin', 'B3438793E2257FBE81A4517E8D37C90C', '贲海龙', 'uplodefiles/touxian.jpg', '1'), ('76bde97a1fd34007bbafcd9f75eb8b5f', 'ben12', 'A977961FFB3F67313125AF7CEFC7F2F4', 'ben123', 'uplodefiles/6f6de1521c964787ba4efd9836bcbd9a.jpeg', '1');
COMMIT;

-- ----------------------------
--  Table structure for `kit_adv_hello`
-- ----------------------------
DROP TABLE IF EXISTS `kit_adv_hello`;
CREATE TABLE `kit_adv_hello` (
  `ah_id` varchar(111) NOT NULL COMMENT '欢迎banner的唯一id',
  `ah_sequence` int(4) NOT NULL COMMENT '序号（数字越大越靠前，1-9999之间，默认是50）',
  `ah_img` varchar(200) NOT NULL COMMENT '图片地址',
  `ah_url` varchar(200) DEFAULT NULL COMMENT '图片需要跳转的地址',
  `ah_time` datetime NOT NULL COMMENT '发布时间',
  `ah_start_time` datetime DEFAULT NULL COMMENT '开始时间',
  `ah_end_time` datetime DEFAULT NULL COMMENT '结束时间',
  `ah_type` int(1) NOT NULL COMMENT '是否关闭（关闭将不显示，1：显示，2：关闭）',
  `ah_title` varchar(50) NOT NULL COMMENT '标题',
  `ah_summary` varchar(200) DEFAULT NULL COMMENT '概述（1-100之间）',
  PRIMARY KEY (`ah_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='APP首次登录的幻灯片设置';

-- ----------------------------
--  Records of `kit_adv_hello`
-- ----------------------------
BEGIN;
INSERT INTO `kit_adv_hello` VALUES ('1', '50', 'http://www.benhailong.com/img', 'http://www.baidu.com', '2018-02-17 19:07:29', '2018-02-17 19:07:32', '2018-02-18 19:07:34', '2', '这里是标题', '这里是文字说明内容，说明内容'), ('4b66d8cdce3544cda95194760f48fee8', '51', 'uplodefiles/2add91923b2f4ad48e6016755a7e8820.jpeg', null, '2018-02-24 12:40:24', '2018-02-01 00:00:00', '2018-03-22 00:00:00', '1', 'ben1', 'ces1');
COMMIT;

-- ----------------------------
--  Table structure for `kit_file_qiniu`
-- ----------------------------
DROP TABLE IF EXISTS `kit_file_qiniu`;
CREATE TABLE `kit_file_qiniu` (
  `fq_id` int(1) NOT NULL,
  `fq_accessKey` varchar(255) DEFAULT NULL,
  `fq_secretKey` varchar(255) DEFAULT NULL,
  `fq_bucket` varchar(255) DEFAULT NULL COMMENT '创建的空间名字',
  `fq_key` varchar(255) DEFAULT NULL COMMENT '需要替换的文件名字',
  PRIMARY KEY (`fq_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='七牛云配置';

-- ----------------------------
--  Records of `kit_file_qiniu`
-- ----------------------------
BEGIN;
INSERT INTO `kit_file_qiniu` VALUES ('1', 'aaa11', 'sss2', 'ddd3', 'fff');
COMMIT;

-- ----------------------------
--  Table structure for `kit_g_group`
-- ----------------------------
DROP TABLE IF EXISTS `kit_g_group`;
CREATE TABLE `kit_g_group` (
  `group_id` int(4) NOT NULL AUTO_INCREMENT COMMENT '分组id',
  `group_name` varchar(50) DEFAULT NULL COMMENT '分组名字',
  PRIMARY KEY (`group_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `kit_g_group`
-- ----------------------------
BEGIN;
INSERT INTO `kit_g_group` VALUES ('1', '超级管理员');
COMMIT;

-- ----------------------------
--  Table structure for `kit_g_group_limit`
-- ----------------------------
DROP TABLE IF EXISTS `kit_g_group_limit`;
CREATE TABLE `kit_g_group_limit` (
  `gl_id` varchar(111) NOT NULL COMMENT '列表ID',
  `group_id` int(4) DEFAULT NULL COMMENT '分组ID',
  `limit_id` int(5) DEFAULT NULL COMMENT '功能id',
  `group_c` int(1) NOT NULL DEFAULT '1' COMMENT '是否有增加按钮，1 为 有，2 为没有',
  `group_r` int(1) NOT NULL DEFAULT '1' COMMENT '是否有删除按钮，1 为 有，2 为没有',
  `group_u` int(1) NOT NULL DEFAULT '1' COMMENT '是否有修改按钮，1 为 有，2 为没有',
  `group_d` int(1) NOT NULL DEFAULT '1' COMMENT '是否有查询按钮，1 为 有，2 为没有',
  PRIMARY KEY (`gl_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='分组和权限关联表';

-- ----------------------------
--  Records of `kit_g_group_limit`
-- ----------------------------
BEGIN;
INSERT INTO `kit_g_group_limit` VALUES ('008a6c8ea4ea41219c3fc39d90940be0', '1', '3', '1', '1', '1', '1'), ('0ebea47145dd4da5852d1cbd90b77f18', '1', '2', '1', '1', '1', '1'), ('1dff970a7b2248f9a5eb6e86b147fbcd', '1', '24', '1', '1', '1', '1'), ('1ee01456c61a4ec7a4d91491e8d9caa9', '1', '22', '1', '1', '1', '1'), ('20e95fcca7a34073bbbd419cc8fb6f7d', '1', '23', '1', '1', '1', '1'), ('369efdb347754f829d936d97a2584f0a', '1', '1', '1', '1', '1', '1'), ('3c26653ccf3244688ad885bf36131ccd', '1', '4', '1', '1', '1', '1'), ('6a1ada14b4e5479cba48978a00146e1e', '1', '21', '1', '1', '1', '1'), ('7da2ccd0c01f408893085a2047bb4145', '1', '19', '1', '1', '1', '1'), ('aca8950c976d480698df8059ec6c24ec', '1', '5', '1', '1', '1', '1'), ('ba29d09a7b9945eb8bda6c399d9ef020', '1', '16', '1', '1', '1', '1'), ('cd11aedf033a4d06b3fce690bad64a7c', '1', '25', '1', '1', '1', '1'), ('e5e88d8efc904a4d937c979c515d820c', '1', '20', '1', '1', '1', '1');
COMMIT;

-- ----------------------------
--  Table structure for `kit_g_limit`
-- ----------------------------
DROP TABLE IF EXISTS `kit_g_limit`;
CREATE TABLE `kit_g_limit` (
  `limit_id` int(5) unsigned NOT NULL AUTO_INCREMENT COMMENT '功能id',
  `limit_sequence` int(4) NOT NULL DEFAULT '50' COMMENT '排序',
  `limit_ico` varchar(50) NOT NULL COMMENT '图标',
  `limit_title` varchar(50) NOT NULL COMMENT '标题',
  `limit_action` varchar(100) NOT NULL COMMENT '路径',
  `limit_leaderid` int(5) NOT NULL DEFAULT '0' COMMENT '上级ID',
  `limit_system` int(2) NOT NULL DEFAULT '1' COMMENT '是否允许编辑，1：允许修改，2：不允许修改',
  PRIMARY KEY (`limit_id`)
) ENGINE=InnoDB AUTO_INCREMENT=26 DEFAULT CHARSET=utf8 COMMENT='功能表';

-- ----------------------------
--  Records of `kit_g_limit`
-- ----------------------------
BEGIN;
INSERT INTO `kit_g_limit` VALUES ('1', '50', '&#xe614;', '系统工具', '/', '0', '2'), ('2', '1', '&#xe631;', '系统配置', '/web/getModelReturn', '1', '2'), ('3', '2', '&#xe62a;', '菜单管理', '/gLimit/getGroup', '1', '2'), ('4', '3', '&#xe613;', '分组管理', '/gGroup/getAll', '1', '2'), ('5', '4', '&#xe612;', '管理员管理', '/admin/getAll', '1', '2'), ('16', '50', '&#xe634;', '广告设置', 'test', '0', '2'), ('19', '5', '&#xe681;', '文件存储设置', '/file/getAll', '1', '2'), ('20', '6', '&#xe609;', '短信设置', '/message/index', '1', '2'), ('21', '50', '&#xe60d;', 'APP首登幻灯片', '/advhello/getAll', '16', '2'), ('22', '7', '&#xe645;', '推送设置', '/push/getAll', '1', '2'), ('23', '50', '&#xe612;', '会员管理', '/', '0', '2'), ('24', '50', '&#xe60c;', '用户管理', '/user/getAll', '23', '2'), ('25', '8', '&#xe659;', '支付设置', '/pay/getAll', '1', '2');
COMMIT;

-- ----------------------------
--  Table structure for `kit_message`
-- ----------------------------
DROP TABLE IF EXISTS `kit_message`;
CREATE TABLE `kit_message` (
  `id` int(1) NOT NULL COMMENT 'id',
  `key_Id` varchar(111) DEFAULT NULL COMMENT '请输入你在阿里大鱼后台的AccessKeyId',
  `ket_secret` varchar(255) DEFAULT NULL COMMENT '请输入你在阿里大鱼后台的AccessKeySecret',
  `sign_name` varchar(111) DEFAULT NULL COMMENT '阿里大鱼认证通过的短信签名',
  `template_dayu` varchar(50) DEFAULT NULL COMMENT '这里是阿里大鱼默认的短信模板',
  `sid` varchar(111) DEFAULT NULL COMMENT '请输入你在云之讯的唯一标识',
  `app_id` varchar(255) DEFAULT NULL COMMENT '云之讯的AppId',
  `token` varchar(255) DEFAULT NULL COMMENT '请输入你在云之讯的token',
  `template_yzx` varchar(50) DEFAULT NULL COMMENT '云之讯的默认短信模板',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
--  Records of `kit_message`
-- ----------------------------
BEGIN;
INSERT INTO `kit_message` VALUES ('1', 'LTAI0eMlIfLxPHxi', '2BYQoKK7RfWJfFa3DC1GR3OcymiUQT', 'OpenKit社区', 'SMS_126420110', '983def4ac6b7b08dfdffc2553c92088e', '0568650962be47c6bcfa8cd0ffabbb11', 'e9b5105ca902bca5dac47f162afe9062', '186059');
COMMIT;

-- ----------------------------
--  Table structure for `kit_pay_setting`
-- ----------------------------
DROP TABLE IF EXISTS `kit_pay_setting`;
CREATE TABLE `kit_pay_setting` (
  `ps_id` int(1) NOT NULL COMMENT '唯一id',
  `pay_is_alipay` int(1) NOT NULL COMMENT '是否开启支付宝支付',
  `pay_is_weixin` int(1) NOT NULL COMMENT '是否开启微信支付',
  PRIMARY KEY (`ps_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
--  Records of `kit_pay_setting`
-- ----------------------------
BEGIN;
INSERT INTO `kit_pay_setting` VALUES ('1', '1', '1');
COMMIT;

-- ----------------------------
--  Table structure for `kit_pay_setting_alipay`
-- ----------------------------
DROP TABLE IF EXISTS `kit_pay_setting_alipay`;
CREATE TABLE `kit_pay_setting_alipay` (
  `psa_id` int(1) NOT NULL,
  `psa_app_id` varchar(255) DEFAULT NULL COMMENT 'appId',
  `psa_private_key` text COMMENT '密钥',
  `psa_public_key` text COMMENT '支付宝公钥',
  `psa_server_url` varchar(255) DEFAULT NULL COMMENT '支付宝开放安全地址(一半不需要修改)',
  `psa_do_main` varchar(100) DEFAULT NULL COMMENT '支付宝返回回调地址前缀',
  `psa_charset` varchar(30) DEFAULT NULL COMMENT '设置字符集编码',
  `psa_format` varchar(30) DEFAULT 'JSON' COMMENT '仅支持JSON',
  `psa_sign_type` varchar(30) DEFAULT 'RSA2' COMMENT '设置符号类型',
  PRIMARY KEY (`psa_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
--  Records of `kit_pay_setting_alipay`
-- ----------------------------
BEGIN;
INSERT INTO `kit_pay_setting_alipay` VALUES ('1', '2017101309290056', 'MIIEvQIBADANBgkqhkiG9w0BAQEFAASCBKcwggSjAgEAAoIBAQClMv0WoKfCGN+eJsWtkeH+9MtAK/arN450AEoGAC2udqgidMLAzIP2/y1lZzs7wssAW0mzdDM3WawmFdEQocRqXET9Ef99TEMc40RzwjJZsDuUDJ3KgUo5H9a9Hm3LhWqYI8pF9gaGsXyOzMssQDqqDSi9A7AhkE3jafsGs3r/op2GAyCQWfFifVq0tv9M1d7+3ErOCJWIkRbGGr5mFFl6S8QpIREMSGhvASMtsMjT9IawGhA/CbtBVMd3L6K96KilicXDEpDeRWLy1iMz5jS3MoVgwME3Yj5PGt38Z+n1tx2fFFPgzpQhpgLJeHDGl1mtB0qafHkLaNdhZZ2hP+xtAgMBAAECggEAFXipGHXNGBcviVi0vLiHTSH4AOE18E8KPt2CwYDobxKRC9ltLq3mQQYtmk5ujnfk9qjmzWI+/eSz0UdooubDpqdTeCkMsfZliq2nSfxlmu6i770sDRP816vhtzbrQlaW4itUsP8nHf6Xl9/aUGgQt+V59Ac0r0gYN4Sg0eAmDm+YonIvhGVL9BNZBAq7Q/udptSzBWQXIZUn92iK8C2rcv8Bi6j4sl2W2VgAZHn00Z9tO7y/m7AZhtHBUP7sXMV3Jle+ThdgqjCApEnmywW218bPVxUvajCvLC9d9VQnJLff7bWoFKRLC7TIwsk87LbwjBiCOYVxe3a3wwSZBwH7QQKBgQDiMVvL4Srx/spkFndY36lqerlROKNsOzLkq7qrRdVKcr2Ej2GH95uNz4O6yXJTkSdSwqEhxFfKz+So6SsVKQDObCRzSGXVFSV7ctQPDKQ7UTWexfIKXofJjLFWwscgS84lYssFmuXpaTkKoaXTFiTJQRWubVaZkKacQGDWqvc/WQKBgQC6+ACnA8qL8NqKrrnPdXEraVFh/QxOVq0SKzCy/dilVvHUxMUdYxuJVDWGyre3kp4cz6jMFZoo+iUpHHdwUXg79zCl6gEaOnQH0Hn2MRmlUpVcetBxQsK7imAWQuGhThgx86DUThKC7c6Ct6lFNjEg80Z5Eoey2iTkOIKU9stnNQKBgQCsGI/WTEhHfOryQeGmPe4BdMRg1q4IX/Y1468QNv60OR6WqBy1vZ+dwuBgEnsot8zqe+jq7x840PoRxe4gmGTjqYYGLHRGLmOpTFGp7Z1bAEvCtKqWVxwLLj+TWnj0ypha+5KqfhMlhwh+XUT0mOl+MkXTw57bEiKhyZ2kVsntaQKBgENsBUg07Mh0DUrvYR/3uNyvuOI+Dz78sKKZopEZSxOse75/SpmjUJ3AGSFHXuK643t+Qt99dr8KHXZqxoNhTZtKM2fRL56Wr5rVyfVGlXnxgtz7iMkfCvv4FVhRu+2gLMdulHOax8AhI1QuCMNlnGfGcoZccUTEt4L5AdXX/Vd1AoGAVqw2vs83klWuMBgfB/qBIkkGvt1R7IqNXt7oVZBLFp0g2vH3i1iRpOtx0G0BWvs4cu8BAAIMeOxma+c3hLNsBzeIpRknnlGSsaFgGunUmu8090Km3qWLNAyp1GUWnemjQAc3n3nN1KBFx3UebGw8URIwdRK+qWCL8oi7A4BGRlQ=', 'MIIBIjANBgkqhkiG9w0BAQEFAAOCAQ8AMIIBCgKCAQEAyUnB4k1thOJWsZJTI1SFENPb+UhZ0JI3fsjc9B/cCtO7+c3eeb82glDs4TxI8kUp05ckazV5mPJqjMzySW3Wjfdh6POJcD5wR5KxYuYe1Rz8D++LJGvCTvK+HQ1gVrQEG1kB580BiC71nhUoJAEEesAtCEJ34y/IdbOqh2XAg2Li1IVVQxU5r2AQUilEfJW8ClCx1g/3Yb7xCEByi7qnCVaMf1AEAtOSkSntEVGaowx5sL5nWEBoQ9gYP8cs3OymTO9Z5H7NOlkhYt5EquzzUqxWrd+cNnLsMe0pF8zElc9W8U4InPuB3UAvR2p2Y8g/kGTMUCof73LVR0yykXNUMwIDAQAB', 'https://openapi.alipay.com/gateway.do', 'http://yj.xw025.com', 'UTF-8', 'JSON', 'RSA2');
COMMIT;

-- ----------------------------
--  Table structure for `kit_pay_setting_weixin`
-- ----------------------------
DROP TABLE IF EXISTS `kit_pay_setting_weixin`;
CREATE TABLE `kit_pay_setting_weixin` (
  `psw_id` int(1) NOT NULL COMMENT '唯一标识',
  `psw_app_id` varchar(255) DEFAULT NULL COMMENT '微信开发平台应用ID',
  `psw_app_secret` varchar(255) DEFAULT NULL COMMENT '应用对应的凭证',
  `psw_app_key` varchar(255) DEFAULT NULL COMMENT '应用对应的密钥',
  `psw_mchId` varchar(255) DEFAULT NULL COMMENT '微信支付商户号',
  `psw_body` varchar(255) DEFAULT NULL COMMENT '商品描述',
  `psw_partner_key` varchar(255) DEFAULT NULL COMMENT '商户号对应的密钥',
  `psw_partner_id` varchar(255) DEFAULT NULL COMMENT '商户id',
  `psw_grant_type` varchar(255) DEFAULT NULL COMMENT '常量固定值',
  `psw_gate_url` varchar(255) DEFAULT NULL COMMENT '获取预支付id的接口url',
  `psw_notify_url` varchar(255) DEFAULT NULL COMMENT '微信服务器回调通知url',
  `psw_spbill_createIp` varchar(30) DEFAULT NULL COMMENT '请求的 IP 地址，其实就是服务器的IP地址',
  PRIMARY KEY (`psw_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
--  Records of `kit_pay_setting_weixin`
-- ----------------------------
BEGIN;
INSERT INTO `kit_pay_setting_weixin` VALUES ('1', 'wx92919d8a0efc26b9', '7f61f87579af638a66ec19a9dac0030d', 'e10adc3949ba59abbe56e057f20f883e', '1490777982', '书籍', 'e10adc3949ba59abbe56e057f20f883e', '1490777982', 'client_credential', 'https://api.mch.weixin.qq.com/pay/unifiedorder', 'http://www.bairuoheng.cn/app/notify', '36.149.156.246');
COMMIT;

-- ----------------------------
--  Table structure for `kit_push_jpush`
-- ----------------------------
DROP TABLE IF EXISTS `kit_push_jpush`;
CREATE TABLE `kit_push_jpush` (
  `pj_id` int(1) NOT NULL,
  `pj_appkey` varchar(255) DEFAULT NULL COMMENT '极光推送的appkey',
  `pj_mastersecret` varchar(255) DEFAULT NULL COMMENT '极光推送的mastersecret',
  PRIMARY KEY (`pj_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='极光推送配置文件\n';

-- ----------------------------
--  Records of `kit_push_jpush`
-- ----------------------------
BEGIN;
INSERT INTO `kit_push_jpush` VALUES ('1', 'awdasd', 'asdsad11111');
COMMIT;

-- ----------------------------
--  Table structure for `kit_sign`
-- ----------------------------
DROP TABLE IF EXISTS `kit_sign`;
CREATE TABLE `kit_sign` (
  `sign_id` varchar(64) NOT NULL COMMENT '唯一标识',
  `sign_phone` varchar(11) NOT NULL COMMENT '手机号码',
  `sign_code` varchar(64) NOT NULL COMMENT 'MD5( 验证码+盐）',
  `sign_time` datetime NOT NULL COMMENT '发送时间',
  `sign_type` int(1) NOT NULL COMMENT '状态（1：未使用，2：已经使用）',
  PRIMARY KEY (`sign_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
--  Records of `kit_sign`
-- ----------------------------
BEGIN;
INSERT INTO `kit_sign` VALUES ('b62c6ae252e24e27b00f6329c789ab07', '17714198992', '3EB6BFF7A6D300F350351B2ECC225E9D', '2018-02-28 12:41:46', '1'), ('d19ed87a8e7a49ee8b63621dcf5897be', '17714198992', 'A50F34F315CCF4D6E25AC0070EB12356', '2018-02-28 12:54:22', '1'), ('f13932cd8ec84b738ce9ac3f9c850090', '15850652758', '5C6D92BB41B2A07EABBFDDCA7E69CA1B', '2018-02-28 12:49:15', '1'), ('f53a0ede186244508f6cbafc734245ea', '15850652758', '4C57618F41CF97886AF7F55F2E01B9E5', '2018-02-28 12:51:34', '1');
COMMIT;

-- ----------------------------
--  Table structure for `kit_user`
-- ----------------------------
DROP TABLE IF EXISTS `kit_user`;
CREATE TABLE `kit_user` (
  `user_id` varchar(111) NOT NULL,
  `user_name` varchar(50) DEFAULT NULL COMMENT '用户名',
  `user_login_name` varchar(50) DEFAULT NULL COMMENT '登录用户名',
  `user_password` varchar(100) DEFAULT NULL COMMENT 'md5加密的',
  `user_phone` varchar(11) DEFAULT NULL COMMENT '手机号码',
  `user_email` varchar(30) DEFAULT NULL COMMENT '邮箱',
  `user_img` varchar(100) DEFAULT NULL COMMENT '头像地址',
  `user_token` varchar(111) DEFAULT NULL COMMENT '用户登录token',
  `user_time` datetime NOT NULL COMMENT '注册时间',
  `user_update_time` datetime DEFAULT NULL COMMENT '用户最后修改的时间',
  `user_type` int(1) DEFAULT '1' COMMENT '用户状态（1：正常，2：锁定）',
  PRIMARY KEY (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='用户表';

-- ----------------------------
--  Records of `kit_user`
-- ----------------------------
BEGIN;
INSERT INTO `kit_user` VALUES ('1111', '大奔老师', 'bigben', 'asbdaijd', '15651019222', '694201656@qq.com', 'tausdhiasj.jpg', 'asdasasdasdsad', '2018-02-24 21:55:38', '2018-02-24 21:55:41', '1'), ('4caa947b66954519806f4fccd96c5ca7', 'ben1', 'ben1', 'A977961FFB3F67313125AF7CEFC7F2F4', '13295126493', '2@2.com', 'http://localhost:8080/uplodefiles/11655cac94d54efea933b85cc27df15b.jpeg', null, '2018-02-25 21:27:40', '2018-02-25 21:51:38', '1');
COMMIT;

-- ----------------------------
--  Table structure for `kit_user_login_setting`
-- ----------------------------
DROP TABLE IF EXISTS `kit_user_login_setting`;
CREATE TABLE `kit_user_login_setting` (
  `uls_id` int(1) NOT NULL COMMENT '唯一id',
  `uls_type` int(2) NOT NULL COMMENT '登录方式（1：账号+密码，2：手机号码+密码，3：邮箱+密码，4：手机号码+验证码）',
  `uls_is_weixin` int(1) NOT NULL DEFAULT '2' COMMENT '是否开启微信登录，开启后需要设置微信登录的信息（1：开启，2：登录）',
  `uls_is_qq` int(1) NOT NULL DEFAULT '2' COMMENT '是否开启QQ登录，开启后需要设置QQ登录的信息（1：开启，2：登录）',
  `uls_is_weibo` int(1) NOT NULL DEFAULT '2' COMMENT '是否开启微博登录，开启后需要设置微博登录的信息（1：开启，2：登录）',
  `uls_is_register` int(1) NOT NULL DEFAULT '1' COMMENT '是否允许注册（1：允许，2：不允许）',
  `uls_login_is_registration` int(1) NOT NULL DEFAULT '2' COMMENT '是否开启登录就是注册（1：可以，2：不开启）',
  PRIMARY KEY (`uls_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
--  Records of `kit_user_login_setting`
-- ----------------------------
BEGIN;
INSERT INTO `kit_user_login_setting` VALUES ('1', '1', '2', '2', '2', '1', '2');
COMMIT;

-- ----------------------------
--  Table structure for `kit_web_setting`
-- ----------------------------
DROP TABLE IF EXISTS `kit_web_setting`;
CREATE TABLE `kit_web_setting` (
  `kit_web_id` int(11) NOT NULL AUTO_INCREMENT,
  `kit_web_name` varchar(50) NOT NULL COMMENT '网站名称',
  `kit_web_message` int(1) DEFAULT NULL COMMENT '短信设置（1：阿里大鱼，2：云之讯）',
  `kit_web_push` int(1) DEFAULT NULL COMMENT '推送设置（1：极光，2：云之讯）',
  `kit_web_file` int(1) DEFAULT NULL COMMENT '文件存储（1：本地，2：七牛云）',
  `kit_sige_size` int(1) DEFAULT NULL COMMENT '验证码位数',
  `kit_web_hellow_adv_size` int(2) DEFAULT NULL COMMENT '首次登录欢迎界面的显示个数（0-10之间）',
  `kit_sign_active_time` int(2) DEFAULT NULL COMMENT '验证码有效时间（单位分钟）',
  PRIMARY KEY (`kit_web_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COMMENT='项目配置表，有且仅有一条数据，不要删除';

-- ----------------------------
--  Records of `kit_web_setting`
-- ----------------------------
BEGIN;
INSERT INTO `kit_web_setting` VALUES ('1', 'Kit-Admin', '1', '1', '2', '6', '3', '5');
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
